from django.db import models

class Admin(models.Model):
    """管理员"""
    objects = None
    username = models.CharField(verbose_name="用户名",max_length=32)
    password = models.CharField(verbose_name="密码",max_length=64)



class Department(models.Model):
    '''部门表'''
    objects = None
    title = models.CharField(verbose_name="标题",max_length=32)
    def __str__(self):
        return self.title

class  UserInfo(models.Model):
    '''员工表'''
    objects = None
    name = models.CharField(verbose_name="姓名",max_length=16)
    password = models.CharField(verbose_name="密码",max_length=64)
    age = models.IntegerField(verbose_name="年龄")
    account = models.DecimalField(verbose_name="账户余额",max_digits=10,decimal_places=2,default=0)
    create_time = models.DateTimeField(verbose_name="入职时间")

    # 在django中坐约束
    gender_choices = ((1,"男"),(2,"女"))
    gender = models.SmallIntegerField(verbose_name="性别",choices=gender_choices)

    # 无约束
    # depart_id = models.CharField(verbose_name="部门ID")

    # 1.有约束
    #     — to,与哪张表关联
    #     - to_field ,与表中的哪一列关联
    # 2. django自动
    #       - 写的depart
    #       - 自动生成数列，depart_id
    # 3.部门表被删除
    #   3.1 级联删除 on_delete=models.CASCADE
    #   3.2 置空 null=True,on_deleta=models.SET_NULL

    depart = models.ForeignKey(verbose_name="部门",to="Department",to_field="id", null=True,on_delete=models.SET_NULL)


class PrettyNum(models.Model):
    """靓号表"""
    objects = None
    phone = models.CharField(verbose_name="手机号",max_length=32)
    price = models.IntegerField(verbose_name="价格")
    level_choices = ((1,"1级"),(2,"2级"),(3,"3级"))
    level = models.SmallIntegerField(verbose_name="级别",choices=level_choices,default=1)

    status_choices = ((1,"未占用"),(2,"已占用"))
    status = models.SmallIntegerField(verbose_name="状态",choices=status_choices,default=1)




